﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Groep18_AvartonScannerDataSet" targetNamespace="http://tempuri.org/Groep18_AvartonScannerDataSet.xsd" xmlns:mstns="http://tempuri.org/Groep18_AvartonScannerDataSet.xsd" xmlns="http://tempuri.org/Groep18_AvartonScannerDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Groep18_ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Groep18_ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Avarton_Scanner.Properties.Settings.GlobalReference.Default.Groep18_ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblClientTableAdapter" GeneratorDataComponentClassName="tblClientTableAdapter" Name="tblClient" UserDataComponentName="tblClientTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Groep18_ConnectionString (Settings)" DbObjectName="dbo.tblClient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblClient] WHERE (([ID] = @Original_ID) AND ([FirstSeen] = @Original_FirstSeen) AND ([LastSeen] = @Original_LastSeen) AND ([ConnectionTimeInSeconds] = @Original_ConnectionTimeInSeconds))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FirstSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FirstSeen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastSeen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ConnectionTimeInSeconds" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ConnectionTimeInSeconds" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblClient] ([SSID], [MAC], [IP], [FirstSeen], [LastSeen], [ConnectionTimeInSeconds], [Domain], [Hostname]) VALUES (@SSID, @MAC, @IP, @FirstSeen, @LastSeen, @ConnectionTimeInSeconds, @Domain, @Hostname);
SELECT ID, SSID, MAC, IP, FirstSeen, LastSeen, ConnectionTimeInSeconds, Domain, Hostname FROM tblClient WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SSID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SSID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MAC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MAC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FirstSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FirstSeen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastSeen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ConnectionTimeInSeconds" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ConnectionTimeInSeconds" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Domain" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Domain" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Hostname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hostname" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, SSID, MAC, IP, FirstSeen, LastSeen, ConnectionTimeInSeconds, Domain, Hostname FROM dbo.tblClient</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblClient] SET [SSID] = @SSID, [MAC] = @MAC, [IP] = @IP, [FirstSeen] = @FirstSeen, [LastSeen] = @LastSeen, [ConnectionTimeInSeconds] = @ConnectionTimeInSeconds, [Domain] = @Domain, [Hostname] = @Hostname WHERE (([ID] = @Original_ID) AND ([FirstSeen] = @Original_FirstSeen) AND ([LastSeen] = @Original_LastSeen) AND ([ConnectionTimeInSeconds] = @Original_ConnectionTimeInSeconds));
SELECT ID, SSID, MAC, IP, FirstSeen, LastSeen, ConnectionTimeInSeconds, Domain, Hostname FROM tblClient WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SSID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SSID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MAC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MAC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FirstSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FirstSeen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastSeen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ConnectionTimeInSeconds" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ConnectionTimeInSeconds" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Domain" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Domain" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Hostname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hostname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FirstSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FirstSeen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastSeen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ConnectionTimeInSeconds" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ConnectionTimeInSeconds" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="[C:\USERS\ADMINISTRATOR\DESKTOP\AVARTON SCANNER\CONNECTION\GROEP18_AVARTONSCANNER.MDF].dbo.tblClient" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="SSID" DataSetColumn="SSID" />
              <Mapping SourceColumn="MAC" DataSetColumn="MAC" />
              <Mapping SourceColumn="IP" DataSetColumn="IP" />
              <Mapping SourceColumn="FirstSeen" DataSetColumn="FirstSeen" />
              <Mapping SourceColumn="LastSeen" DataSetColumn="LastSeen" />
              <Mapping SourceColumn="ConnectionTimeInSeconds" DataSetColumn="ConnectionTimeInSeconds" />
              <Mapping SourceColumn="Domain" DataSetColumn="Domain" />
              <Mapping SourceColumn="Hostname" DataSetColumn="Hostname" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblNetworkTableAdapter" GeneratorDataComponentClassName="tblNetworkTableAdapter" Name="tblNetwork" UserDataComponentName="tblNetworkTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Groep18_ConnectionString (Settings)" DbObjectName="dbo.tblNetwork" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblNetwork] WHERE (([ID] = @Original_ID) AND ([FirstSeen] = @Original_FirstSeen) AND ([LastSeen] = @Original_LastSeen))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FirstSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FirstSeen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastSeen" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblNetwork] ([SSID], [MAC], [IP], [FirstSeen], [LastSeen]) VALUES (@SSID, @MAC, @IP, @FirstSeen, @LastSeen);
SELECT ID, SSID, MAC, IP, FirstSeen, LastSeen FROM tblNetwork WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SSID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SSID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MAC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MAC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FirstSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FirstSeen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastSeen" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, SSID, MAC, IP, FirstSeen, LastSeen FROM dbo.tblNetwork</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblNetwork] SET [SSID] = @SSID, [MAC] = @MAC, [IP] = @IP, [FirstSeen] = @FirstSeen, [LastSeen] = @LastSeen WHERE (([ID] = @Original_ID) AND ([FirstSeen] = @Original_FirstSeen) AND ([LastSeen] = @Original_LastSeen));
SELECT ID, SSID, MAC, IP, FirstSeen, LastSeen FROM tblNetwork WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SSID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SSID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MAC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MAC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FirstSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FirstSeen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastSeen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FirstSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FirstSeen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastSeen" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastSeen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="[C:\USERS\ADMINISTRATOR\DESKTOP\AVARTON SCANNER\CONNECTION\GROEP18_AVARTONSCANNER.MDF].dbo.tblNetwork" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="SSID" DataSetColumn="SSID" />
              <Mapping SourceColumn="MAC" DataSetColumn="MAC" />
              <Mapping SourceColumn="IP" DataSetColumn="IP" />
              <Mapping SourceColumn="FirstSeen" DataSetColumn="FirstSeen" />
              <Mapping SourceColumn="LastSeen" DataSetColumn="LastSeen" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Groep18_AvartonScannerDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Groep18_AvartonScannerDataSet" msprop:Generator_UserDSName="Groep18_AvartonScannerDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblClient" msprop:Generator_TableClassName="tblClientDataTable" msprop:Generator_TableVarName="tabletblClient" msprop:Generator_TablePropName="tblClient" msprop:Generator_RowDeletingName="tblClientRowDeleting" msprop:Generator_UserTableName="tblClient" msprop:Generator_RowChangingName="tblClientRowChanging" msprop:Generator_RowEvHandlerName="tblClientRowChangeEventHandler" msprop:Generator_RowDeletedName="tblClientRowDeleted" msprop:Generator_RowEvArgName="tblClientRowChangeEvent" msprop:Generator_RowChangedName="tblClientRowChanged" msprop:Generator_RowClassName="tblClientRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="SSID" msprop:Generator_ColumnVarNameInTable="columnSSID" msprop:Generator_ColumnPropNameInRow="SSID" msprop:Generator_ColumnPropNameInTable="SSIDColumn" msprop:Generator_UserColumnName="SSID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MAC" msprop:Generator_ColumnVarNameInTable="columnMAC" msprop:Generator_ColumnPropNameInRow="MAC" msprop:Generator_ColumnPropNameInTable="MACColumn" msprop:Generator_UserColumnName="MAC">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IP" msprop:Generator_ColumnVarNameInTable="columnIP" msprop:Generator_ColumnPropNameInRow="IP" msprop:Generator_ColumnPropNameInTable="IPColumn" msprop:Generator_UserColumnName="IP">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstSeen" msprop:Generator_ColumnVarNameInTable="columnFirstSeen" msprop:Generator_ColumnPropNameInRow="FirstSeen" msprop:Generator_ColumnPropNameInTable="FirstSeenColumn" msprop:Generator_UserColumnName="FirstSeen" type="xs:dateTime" />
              <xs:element name="LastSeen" msprop:Generator_ColumnVarNameInTable="columnLastSeen" msprop:Generator_ColumnPropNameInRow="LastSeen" msprop:Generator_ColumnPropNameInTable="LastSeenColumn" msprop:Generator_UserColumnName="LastSeen" type="xs:dateTime" />
              <xs:element name="ConnectionTimeInSeconds" msprop:Generator_ColumnVarNameInTable="columnConnectionTimeInSeconds" msprop:Generator_ColumnPropNameInRow="ConnectionTimeInSeconds" msprop:Generator_ColumnPropNameInTable="ConnectionTimeInSecondsColumn" msprop:Generator_UserColumnName="ConnectionTimeInSeconds" type="xs:long" />
              <xs:element name="Domain" msprop:Generator_ColumnVarNameInTable="columnDomain" msprop:Generator_ColumnPropNameInRow="Domain" msprop:Generator_ColumnPropNameInTable="DomainColumn" msprop:Generator_UserColumnName="Domain">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Hostname" msprop:Generator_ColumnVarNameInTable="columnHostname" msprop:Generator_ColumnPropNameInRow="Hostname" msprop:Generator_ColumnPropNameInTable="HostnameColumn" msprop:Generator_UserColumnName="Hostname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblNetwork" msprop:Generator_TableClassName="tblNetworkDataTable" msprop:Generator_TableVarName="tabletblNetwork" msprop:Generator_TablePropName="tblNetwork" msprop:Generator_RowDeletingName="tblNetworkRowDeleting" msprop:Generator_UserTableName="tblNetwork" msprop:Generator_RowChangingName="tblNetworkRowChanging" msprop:Generator_RowEvHandlerName="tblNetworkRowChangeEventHandler" msprop:Generator_RowDeletedName="tblNetworkRowDeleted" msprop:Generator_RowEvArgName="tblNetworkRowChangeEvent" msprop:Generator_RowChangedName="tblNetworkRowChanged" msprop:Generator_RowClassName="tblNetworkRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="SSID" msprop:Generator_ColumnVarNameInTable="columnSSID" msprop:Generator_ColumnPropNameInRow="SSID" msprop:Generator_ColumnPropNameInTable="SSIDColumn" msprop:Generator_UserColumnName="SSID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MAC" msprop:Generator_ColumnVarNameInTable="columnMAC" msprop:Generator_ColumnPropNameInRow="MAC" msprop:Generator_ColumnPropNameInTable="MACColumn" msprop:Generator_UserColumnName="MAC">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IP" msprop:Generator_ColumnVarNameInTable="columnIP" msprop:Generator_ColumnPropNameInRow="IP" msprop:Generator_ColumnPropNameInTable="IPColumn" msprop:Generator_UserColumnName="IP">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstSeen" msprop:Generator_ColumnVarNameInTable="columnFirstSeen" msprop:Generator_ColumnPropNameInRow="FirstSeen" msprop:Generator_ColumnPropNameInTable="FirstSeenColumn" msprop:Generator_UserColumnName="FirstSeen" type="xs:dateTime" />
              <xs:element name="LastSeen" msprop:Generator_ColumnVarNameInTable="columnLastSeen" msprop:Generator_ColumnPropNameInRow="LastSeen" msprop:Generator_ColumnPropNameInTable="LastSeenColumn" msprop:Generator_UserColumnName="LastSeen" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblClient" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="tblNetwork_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblNetwork" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>